import pymysql
import datetime

db = pymysql.connect(host='172.17.9.105',
                     user='cs_platform',
                     password='cs_platfm_01',
                     database='icrg_test')

c = db.cursor()

sql = f"select count(1) from h_p where crawl_date = '{datetime.date.today()}'"


c.execute(sql)
res = c.fetchone()
print(res[0])

db.commit()
db.close()